Export different Object levels to different Excel columns

I was searching a while for Export solutions DOORS -> Excel.
Have found all the enhanced scripts, but they don't solve my problem.

In DOORS I have a kind of Matrix where the Object Level 1 can have n Level 2 can have n Level 3 can have n Level 4.
Now I want for reporting reasons to export each Level into its own Excel column.

Maybe someone did something similar and can help.

Thanks very much in advance.
SystemAdmin - Thu Jun 10 12:39:52 EDT 2010

Re: Export different Object levels to different Excel columns
jsarkic - Thu Jun 10 14:49:38 EDT 2010

A brute-force solution would be to insert a DOORS column that shows the object ID as follows (or any information you desire):
 

if (level(obj) == 1)
    display identifier(obj) ""

 


Do one column for each level and export the columns that you need to Excel.

 

Re: Export different Object levels to different Excel columns
SystemAdmin - Fri Jun 11 03:37:05 EDT 2010

jsarkic - Thu Jun 10 14:49:38 EDT 2010

A brute-force solution would be to insert a DOORS column that shows the object ID as follows (or any information you desire):
 

if (level(obj) == 1)
    display identifier(obj) ""

 


Do one column for each level and export the columns that you need to Excel.

 

Thanks for your response.
The solution looks logic to me and I tried it within a DXL Attribute, but the column remains empty. Even the check tells me 'no errors'.
I am not a DXL expert, maybe you can give me a hint if I forgot something.

Re: Export different Object levels to different Excel columns
SystemAdmin - Fri Jun 11 07:18:02 EDT 2010

SystemAdmin - Fri Jun 11 03:37:05 EDT 2010
Thanks for your response.
The solution looks logic to me and I tried it within a DXL Attribute, but the column remains empty. Even the check tells me 'no errors'.
I am not a DXL expert, maybe you can give me a hint if I forgot something.

After playing around, I got a solution now which works for me.
Thanks again for your help.